﻿<!DOCTYPE html>
<html>
	<head>
		<title>VLOOKUP Function</title>
		<meta charset="utf-8" />
		<meta name="description" content="" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
			<h1>VLOOKUP Function</h1>
			<p>The <b>VLOOKUP</b> function is one of the <a href="../UsageInstructions/InsertFunction.htm#lookupreference" onclick="onhyperlinkclick(this)">lookup and reference functions</a>. It is used to perform the vertical search for a value in the left-most column of a table or an array and return the value in the same row based on a specified column index number.</p>
			<h3>Syntax</h3> 
			<p><b><em>VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])</em></b></p> 
			<p>The <b>VLOOKUP</b> function has the following arguments:</p> 
			<table style="width: 40%">
                <tr>
                    <th style="background-color: #f4f4f4" width="150ch"><b>Argument</b></th>
                    <th style="background-color: #f4f4f4"><b>Description</b></th>
                </tr>
                <tr>
                    <td><b><em>lookup_value</em></b></td>
                    <td>A value to search for.</td>
                </tr>
				<tr>
                    <td><b><em>table_array</em></b></td>
                    <td>Two or more columns containing data sorted in ascending order.</td>
                </tr>
				<tr>
                    <td><b><em>col_index_num</em></b></td>
                    <td>A column number in the <b><em>table_array</em></b>, a numeric value greater than or equal to 1 but less than the number of columns in the <b>table_array</b>.</td>
                </tr>
				<tr>
                    <td><b><em>range_lookup</em></b></td>
                    <td>A logical value TRUE or FALSE. It is an optional argument. Enter FALSE to find an exact match. Enter TRUE or omit this argument to find an approximate match, in this case if there is not a value that strictly matches the <b><em>lookup_value</em></b>, then the function will choose the next largest value less than the <b><em>lookup_value</em></b>.</td>
                </tr>
            </table>
			
			<h3>Notes</h3>
            <p>If the <b><em>range_lookup</em></b> is set to FALSE, but no exact match is found, then the function will return the <b>#N/A</b> error.</p>
			<p><a href="../UsageInstructions/InsertFunction.htm#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the <b>VLOOKUP</b> function.</p>
			
			<h3>Examples</h3>
            <p>The figure below displays the result returned by the <b>VLOOKUP</b> function.</p>
			<p><img alt="VLOOKUP Function" src="../images/vlookup.png" /></p>
		</div>
	</body>
</html>